Pandas Profiling Report

Dataset statistics

Number of variables	36
Number of observations	91199
Missing cells	56
Missing cells (%)	< 0.1%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	25.0 MiB
Average record size in memory	288.0 B

Variable types

Unsupported	2
Categorical	11
Numeric	23

Alerts

`accident_year` has constant value "2020"	Constant
Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`date` has a high cardinality: 366 distinct values	High cardinality
`time` has a high cardinality: 1438 distinct values	High cardinality
`local_authority_ons_district` has a high cardinality: 378 distinct values	High cardinality
`local_authority_highway` has a high cardinality: 206 distinct values	High cardinality
`lsoa_of_accident_location` has a high cardinality: 25931 distinct values	High cardinality
`location_easting_osgr` is highly correlated with `longitude`	High correlation
`location_northing_osgr` is highly correlated with `latitude`	High correlation
`longitude` is highly correlated with `location_easting_osgr`	High correlation
`latitude` is highly correlated with `location_northing_osgr`	High correlation
`police_force` is highly correlated with `local_authority_district`	High correlation
`local_authority_district` is highly correlated with `police_force`	High correlation
`first_road_class` is highly correlated with `first_road_number`	High correlation
`first_road_number` is highly correlated with `first_road_class`	High correlation
`speed_limit` is highly correlated with `urban_or_rural_area`	High correlation
`junction_detail` is highly correlated with `junction_control`	High correlation
`junction_control` is highly correlated with `junction_detail`	High correlation
`second_road_class` is highly correlated with `second_road_number`	High correlation
`second_road_number` is highly correlated with `second_road_class`	High correlation
`weather_conditions` is highly correlated with `road_surface_conditions`	High correlation
`road_surface_conditions` is highly correlated with `weather_conditions`	High correlation
`urban_or_rural_area` is highly correlated with `speed_limit`	High correlation
`location_easting_osgr` is highly correlated with `longitude`	High correlation
`location_northing_osgr` is highly correlated with `latitude`	High correlation
`longitude` is highly correlated with `location_easting_osgr`	High correlation
`latitude` is highly correlated with `location_northing_osgr`	High correlation
`police_force` is highly correlated with `local_authority_district` and 1 other fields	High correlation
`local_authority_district` is highly correlated with `police_force` and 1 other fields	High correlation
`speed_limit` is highly correlated with `urban_or_rural_area`	High correlation
`special_conditions_at_site` is highly correlated with `carriageway_hazards`	High correlation
`carriageway_hazards` is highly correlated with `special_conditions_at_site`	High correlation
`urban_or_rural_area` is highly correlated with `speed_limit`	High correlation
`trunk_road_flag` is highly correlated with `police_force` and 1 other fields	High correlation
`location_easting_osgr` is highly correlated with `longitude`	High correlation
`location_northing_osgr` is highly correlated with `latitude`	High correlation
`longitude` is highly correlated with `location_easting_osgr`	High correlation
`latitude` is highly correlated with `location_northing_osgr`	High correlation
`police_force` is highly correlated with `local_authority_district`	High correlation
`local_authority_district` is highly correlated with `police_force`	High correlation
`first_road_class` is highly correlated with `first_road_number`	High correlation
`first_road_number` is highly correlated with `first_road_class`	High correlation
`speed_limit` is highly correlated with `urban_or_rural_area`	High correlation
`junction_detail` is highly correlated with `junction_control`	High correlation
`junction_control` is highly correlated with `junction_detail`	High correlation
`second_road_class` is highly correlated with `second_road_number`	High correlation
`second_road_number` is highly correlated with `second_road_class`	High correlation
`weather_conditions` is highly correlated with `road_surface_conditions`	High correlation
`road_surface_conditions` is highly correlated with `weather_conditions`	High correlation
`urban_or_rural_area` is highly correlated with `speed_limit`	High correlation
`did_police_officer_attend_scene_of_accident` is highly correlated with `accident_year`	High correlation
`accident_severity` is highly correlated with `accident_year`	High correlation
`urban_or_rural_area` is highly correlated with `accident_year`	High correlation
`accident_year` is highly correlated with `did_police_officer_attend_scene_of_accident` and 4 other fields	High correlation
`pedestrian_crossing_human_control` is highly correlated with `accident_year`	High correlation
`trunk_road_flag` is highly correlated with `accident_year`	High correlation
`location_easting_osgr` is highly correlated with `location_northing_osgr` and 5 other fields	High correlation
`location_northing_osgr` is highly correlated with `location_easting_osgr` and 6 other fields	High correlation
`longitude` is highly correlated with `location_easting_osgr` and 5 other fields	High correlation
`latitude` is highly correlated with `location_easting_osgr` and 6 other fields	High correlation
`police_force` is highly correlated with `location_easting_osgr` and 6 other fields	High correlation
`local_authority_district` is highly correlated with `location_easting_osgr` and 6 other fields	High correlation
`first_road_class` is highly correlated with `road_type` and 1 other fields	High correlation
`first_road_number` is highly correlated with `location_northing_osgr` and 2 other fields	High correlation
`road_type` is highly correlated with `first_road_class` and 1 other fields	High correlation
`speed_limit` is highly correlated with `urban_or_rural_area` and 1 other fields	High correlation
`junction_detail` is highly correlated with `junction_control`	High correlation
`junction_control` is highly correlated with `junction_detail` and 1 other fields	High correlation
`second_road_class` is highly correlated with `junction_control` and 1 other fields	High correlation
`second_road_number` is highly correlated with `second_road_class`	High correlation
`pedestrian_crossing_human_control` is highly correlated with `pedestrian_crossing_physical_facilities` and 2 other fields	High correlation
`pedestrian_crossing_physical_facilities` is highly correlated with `pedestrian_crossing_human_control` and 1 other fields	High correlation
`light_conditions` is highly correlated with `weather_conditions` and 1 other fields	High correlation
`weather_conditions` is highly correlated with `light_conditions` and 2 other fields	High correlation
`road_surface_conditions` is highly correlated with `weather_conditions`	High correlation
`special_conditions_at_site` is highly correlated with `pedestrian_crossing_human_control` and 2 other fields	High correlation
`carriageway_hazards` is highly correlated with `pedestrian_crossing_human_control` and 1 other fields	High correlation
`urban_or_rural_area` is highly correlated with `speed_limit` and 1 other fields	High correlation
`did_police_officer_attend_scene_of_accident` is highly correlated with `police_force` and 2 other fields	High correlation
`trunk_road_flag` is highly correlated with `location_easting_osgr` and 9 other fields	High correlation
`accident_index` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`accident_reference` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`first_road_number` has 36524 (40.0%) zeros	Zeros
`junction_detail` has 37978 (41.6%) zeros	Zeros
`second_road_number` has 77627 (85.1%) zeros	Zeros
`pedestrian_crossing_physical_facilities` has 69269 (76.0%) zeros	Zeros
`special_conditions_at_site` has 87309 (95.7%) zeros	Zeros
`carriageway_hazards` has 87881 (96.4%) zeros	Zeros

Reproduction

Analysis started	2022-02-22 14:05:49.185891
Analysis finished	2022-02-22 14:07:42.680583
Duration	1 minute and 53.49 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

accident_index
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

accident_year
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

2020	91199

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020
2nd row	2020
3rd row	2020
4th row	2020
5th row	2020

Common Values

Value	Count	Frequency (%)
2020	91199	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2020	91199	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

accident_reference
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

location_easting_osgr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	75403
Distinct (%)	82.7%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	456487.8764

Minimum	65947
Maximum	655138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	65947
5-th percentile	279683.2
Q1	392890
median	465545
Q3	530168
95-th percentile	581225.8
Maximum	655138
Range	589191
Interquartile range (IQR)	137278

Descriptive statistics

Standard deviation	93512.71181
Coefficient of variation (CV)	0.2048525638
Kurtosis	-0.1485284961
Mean	456487.8764
Median Absolute Deviation (MAD)	65781
Skewness	-0.5775405017
Sum	4.162484701 × 10¹⁰
Variance	8744627269
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
531949	8	< 0.1%
534246	8	< 0.1%
533808	7	< 0.1%
531796	7	< 0.1%
527086	7	< 0.1%
534060	7	< 0.1%
534423	7	< 0.1%
532411	6	< 0.1%
458165	6	< 0.1%
531181	6	< 0.1%
Other values (75393)	91116	99.9%
(Missing)	14	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
65947	1	< 0.1%
71500	1	< 0.1%
75720	1	< 0.1%
78401	1	< 0.1%
82122	1	< 0.1%
113410	1	< 0.1%
129304	1	< 0.1%
129995	1	< 0.1%
130374	1	< 0.1%
131328	1	< 0.1%

Value	Count	Frequency (%)
655138	1	< 0.1%
655131	1	< 0.1%
654820	1	< 0.1%
654771	1	< 0.1%
654695	1	< 0.1%
654693	2	< 0.1%
654660	1	< 0.1%
654613	1	< 0.1%
654558	1	< 0.1%
654536	1	< 0.1%

location_northing_osgr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	75498
Distinct (%)	82.8%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	273764.4962

Minimum	12715
Maximum	1184351
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	12715
5-th percentile	103654.2
Q1	174569
median	208599
Q3	378366
95-th percentile	565786.6
Maximum	1184351
Range	1171636
Interquartile range (IQR)	203797

Descriptive statistics

Standard deviation	147351.5561
Coefficient of variation (CV)	0.5382420224
Kurtosis	1.33924042
Mean	273764.4962
Median Absolute Deviation (MAD)	74450
Skewness	1.187215511
Sum	2.496321559 × 10¹⁰
Variance	2.171248109 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
182843	9	< 0.1%
183562	8	< 0.1%
186515	7	< 0.1%
181602	7	< 0.1%
178579	7	< 0.1%
185193	7	< 0.1%
183119	7	< 0.1%
177708	6	< 0.1%
184800	6	< 0.1%
186269	6	< 0.1%
Other values (75488)	91115	99.9%
(Missing)	14	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12715	1	< 0.1%
15046	1	< 0.1%
15364	1	< 0.1%
15837	1	< 0.1%
17230	1	< 0.1%
17968	1	< 0.1%
19238	1	< 0.1%
19813	1	< 0.1%
19895	1	< 0.1%
19954	1	< 0.1%

Value	Count	Frequency (%)
1184351	1	< 0.1%
1152779	1	< 0.1%
1152256	1	< 0.1%
1145416	1	< 0.1%
1142382	1	< 0.1%
1140156	1	< 0.1%
1139762	1	< 0.1%
1138225	1	< 0.1%
1136276	1	< 0.1%
1135817	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	89589
Distinct (%)	98.2%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1.189257945

Minimum	-7.497375
Maximum	1.756257
Zeros	0
Zeros (%)	0.0%
Negative	77289
Negative (%)	84.7%
Memory size	712.6 KiB

Quantile statistics

Minimum	-7.497375
5-th percentile	-3.8163898
Q1	-2.107789
median	-1.046912
Q3	-0.125238
95-th percentile	0.608147
Maximum	1.756257
Range	9.253632
Interquartile range (IQR)	1.982551

Descriptive statistics

Standard deviation	1.36778622
Coefficient of variation (CV)	-1.15011737
Kurtosis	-0.1042803005
Mean	-1.189257945
Median Absolute Deviation (MAD)	0.942809
Skewness	-0.6049187827
Sum	-108442.4857
Variance	1.870839143
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1.54911	4	< 0.1%
-1.893843	4	< 0.1%
-0.07189	4	< 0.1%
-0.074986	3	< 0.1%
-2.593099	3	< 0.1%
-0.04989	3	< 0.1%
0.011245	3	< 0.1%
-2.028189	3	< 0.1%
0.083897	3	< 0.1%
-0.167672	3	< 0.1%
Other values (89579)	91152	99.9%
(Missing)	14	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-7.497375	1	< 0.1%
-7.412812	1	< 0.1%
-7.378925	1	< 0.1%
-7.321385	1	< 0.1%
-7.306162	1	< 0.1%
-6.842655	1	< 0.1%
-6.50607	1	< 0.1%
-6.50558	1	< 0.1%
-6.504272	1	< 0.1%
-6.498804	1	< 0.1%

Value	Count	Frequency (%)
1.756257	1	< 0.1%
1.755749	1	< 0.1%
1.751341	1	< 0.1%
1.750759	1	< 0.1%
1.750391	1	< 0.1%
1.749486	1	< 0.1%
1.749168	1	< 0.1%
1.749164	1	< 0.1%
1.749136	1	< 0.1%
1.747418	1	< 0.1%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	88748
Distinct (%)	97.3%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	52.3510732

Minimum	49.970479
Maximum	60.541144
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	49.970479
5-th percentile	50.8207238
Q1	51.457237
median	51.763385
Q3	53.297386
95-th percentile	54.9857186
Maximum	60.541144
Range	10.570665
Interquartile range (IQR)	1.840149

Descriptive statistics

Standard deviation	1.327572787
Coefficient of variation (CV)	0.02535903671
Kurtosis	1.301830994
Mean	52.3510732
Median Absolute Deviation (MAD)	0.676633
Skewness	1.178717506
Sum	4773632.61
Variance	1.762449505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.541779	4	< 0.1%
51.550843	4	< 0.1%
51.522078	4	< 0.1%
53.799708	4	< 0.1%
51.524674	3	< 0.1%
51.449779	3	< 0.1%
52.600538	3	< 0.1%
51.402674	3	< 0.1%
51.517151	3	< 0.1%
50.849976	3	< 0.1%
Other values (88738)	91151	99.9%
(Missing)	14	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
49.970479	1	< 0.1%
49.991142	1	< 0.1%
49.993978	1	< 0.1%
49.998169	1	< 0.1%
50.01158	1	< 0.1%
50.019497	1	< 0.1%
50.027984	1	< 0.1%
50.036209	1	< 0.1%
50.03662	1	< 0.1%
50.037038	1	< 0.1%

Value	Count	Frequency (%)
60.541144	1	< 0.1%
60.257	1	< 0.1%
60.252711	1	< 0.1%
60.190964	1	< 0.1%
60.163281	1	< 0.1%
60.143381	1	< 0.1%
60.140294	1	< 0.1%
60.12662	1	< 0.1%
60.109211	1	< 0.1%
60.105296	1	< 0.1%

police_force
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.48804263

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	22
Q3	45
95-th percentile	63
Maximum	99
Range	98
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	24.54896379
Coefficient of variation (CV)	0.8930779144
Kurtosis	0.6762674699
Mean	27.48804263
Median Absolute Deviation (MAD)	21
Skewness	0.8963433425
Sum	2506882
Variance	602.651623
Monotonicity	Increasing

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
1	20906	22.9%
20	3933	4.3%
99	3836	4.2%
46	3405	3.7%
47	3107	3.4%
44	3016	3.3%
43	2767	3.0%
13	2764	3.0%
50	2616	2.9%
42	2536	2.8%
Other values (34)	42313	46.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	20906	22.9%
3	755	0.8%
4	2354	2.6%
5	1717	1.9%
6	2399	2.6%
7	1363	1.5%
10	1690	1.9%
11	601	0.7%
12	1180	1.3%
13	2764	3.0%

Value	Count	Frequency (%)
99	3836	4.2%
63	771	0.8%
62	958	1.1%
61	487	0.5%
60	658	0.7%
55	1158	1.3%
54	961	1.1%
53	695	0.8%
52	2044	2.2%
50	2616	2.9%

accident_severity
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

3	71453
2	18355
1	1391

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	2
5th row	3

Common Values

Value	Count	Frequency (%)
3	71453	78.3%
2	18355	20.1%
1	1391	1.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
3	71453	78.3%
2	18355	20.1%
1	1391	1.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

number_of_vehicles
Real number (ℝ_≥0)

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.835272317

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6772721133
Coefficient of variation (CV)	0.3690308556
Kurtosis	9.143359462
Mean	1.835272317
Median Absolute Deviation (MAD)	0
Skewness	1.517952791
Sum	167375
Variance	0.4586975154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2	57392	62.9%
1	25730	28.2%
3	6241	6.8%
4	1334	1.5%
5	331	0.4%
6	99	0.1%
7	47	0.1%
8	15	< 0.1%
9	3	< 0.1%
10	3	< 0.1%
Other values (3)	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	25730	28.2%
2	57392	62.9%
3	6241	6.8%
4	1334	1.5%
5	331	0.4%
6	99	0.1%
7	47	0.1%
8	15	< 0.1%
9	3	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
13	1	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	3	< 0.1%
9	3	< 0.1%
8	15	< 0.1%
7	47	0.1%
6	99	0.1%
5	331	0.4%
4	1334	1.5%

number_of_casualties
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.267382318

Minimum	1
Maximum	41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	41
Range	40
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6814732733
Coefficient of variation (CV)	0.5377014211
Kurtosis	152.3683194
Mean	1.267382318
Median Absolute Deviation (MAD)	0
Skewness	5.837364345
Sum	115584
Variance	0.4644058223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	74161	81.3%
2	12221	13.4%
3	3214	3.5%
4	1063	1.2%
5	349	0.4%
6	115	0.1%
7	43	< 0.1%
8	14	< 0.1%
9	7	< 0.1%
11	4	< 0.1%
Other values (6)	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	74161	81.3%
2	12221	13.4%
3	3214	3.5%
4	1063	1.2%
5	349	0.4%
6	115	0.1%
7	43	< 0.1%
8	14	< 0.1%
9	7	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
41	1	< 0.1%
19	1	< 0.1%
17	1	< 0.1%
13	1	< 0.1%
12	1	< 0.1%
11	4	< 0.1%
10	3	< 0.1%
9	7	< 0.1%
8	14	< 0.1%
7	43	< 0.1%

date
Categorical

HIGH CARDINALITY

Distinct	366
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

06/02/2020	426
04/11/2020	414
06/03/2020	411
21/01/2020	399
10/01/2020	397
Other values (361)	89152

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	04/02/2020
2nd row	27/04/2020
3rd row	01/01/2020
4th row	01/01/2020
5th row	01/01/2020

Common Values

Value	Count	Frequency (%)
06/02/2020	426	0.5%
04/11/2020	414	0.5%
06/03/2020	411	0.5%
21/01/2020	399	0.4%
10/01/2020	397	0.4%
18/09/2020	397	0.4%
17/01/2020	396	0.4%
14/01/2020	395	0.4%
07/02/2020	391	0.4%
20/01/2020	386	0.4%
Other values (356)	87187	95.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
06/02/2020	426	0.5%
04/11/2020	414	0.5%
06/03/2020	411	0.5%
21/01/2020	399	0.4%
10/01/2020	397	0.4%
18/09/2020	397	0.4%
17/01/2020	396	0.4%
14/01/2020	395	0.4%
07/02/2020	391	0.4%
20/01/2020	386	0.4%
Other values (356)	87187	95.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

day_of_week
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.12155835

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.932200224
Coefficient of variation (CV)	0.4688033167
Kurtosis	-1.190798175
Mean	4.12155835
Median Absolute Deviation (MAD)	2
Skewness	-0.0790988166
Sum	375882
Variance	3.733397707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	14889	16.3%
5	14056	15.4%
4	13564	14.9%
3	13267	14.5%
2	12772	14.0%
7	12336	13.5%
1	10315	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	10315	11.3%
2	12772	14.0%
3	13267	14.5%
4	13564	14.9%
5	14056	15.4%
6	14889	16.3%
7	12336	13.5%

Value	Count	Frequency (%)
7	12336	13.5%
6	14889	16.3%
5	14056	15.4%
4	13564	14.9%
3	13267	14.5%
2	12772	14.0%
1	10315	11.3%

time
Categorical

HIGH CARDINALITY

Distinct	1438
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

17:00	862
16:00	785
15:00	774
17:30	746
18:00	739
Other values (1433)	87293

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	09:00
2nd row	13:55
3rd row	01:25
4th row	01:50
5th row	02:25

Common Values

Value	Count	Frequency (%)
17:00	862	0.9%
16:00	785	0.9%
15:00	774	0.8%
17:30	746	0.8%
18:00	739	0.8%
14:00	699	0.8%
16:30	697	0.8%
15:30	697	0.8%
18:30	629	0.7%
13:00	605	0.7%
Other values (1428)	83966	92.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17:00	862	0.9%
16:00	785	0.9%
15:00	774	0.8%
17:30	746	0.8%
18:00	739	0.8%
14:00	699	0.8%
16:30	697	0.8%
15:30	697	0.8%
18:30	629	0.7%
13:00	605	0.7%
Other values (1428)	83966	92.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

local_authority_district
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	377
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	311.4828123

Minimum	-1
Maximum	941
Zeros	0
Zeros (%)	0.0%
Negative	991
Negative (%)	1.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	5
Q1	63
median	300
Q3	502
95-th percentile	750
Maximum	941
Range	942
Interquartile range (IQR)	439

Descriptive statistics

Standard deviation	253.4563293
Coefficient of variation (CV)	0.8137088765
Kurtosis	-0.5518546196
Mean	311.4828123
Median Absolute Deviation (MAD)	218
Skewness	0.5069198558
Sum	28406921
Variance	64240.11084
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	1801	2.0%
9	1063	1.2%
1	1029	1.1%
204	997	1.1%
-1	991	1.1%
10	932	1.0%
5	897	1.0%
20	892	1.0%
8	888	1.0%
32	863	0.9%
Other values (367)	80846	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	991	1.1%
1	1029	1.1%
2	613	0.7%
3	565	0.6%
4	790	0.9%
5	897	1.0%
6	609	0.7%
7	758	0.8%
8	888	1.0%
9	1063	1.2%

Value	Count	Frequency (%)
941	13	< 0.1%
940	137	0.2%
939	79	0.1%
938	229	0.3%
937	76	0.1%
936	11	< 0.1%
935	120	0.1%
934	128	0.1%
933	9	< 0.1%
932	187	0.2%

local_authority_ons_district
Categorical

HIGH CARDINALITY

Distinct	378
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

E08000025	1802
E09000022	1054
E09000033	1037
E08000035	1009
E09000032	950
Other values (373)	85347

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	E09000032
2nd row	E09000022
3rd row	E09000033
4th row	E09000025
5th row	E09000033

Common Values

Value	Count	Frequency (%)
E08000025	1802	2.0%
E09000022	1054	1.2%
E09000033	1037	1.1%
E08000035	1009	1.1%
E09000032	950	1.0%
E09000030	896	1.0%
E09000028	893	1.0%
E09000008	892	1.0%
E06000052	862	0.9%
E09000010	862	0.9%
Other values (368)	80942	88.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e08000025	1802	2.0%
e09000022	1054	1.2%
e09000033	1037	1.1%
e08000035	1009	1.1%
e09000032	950	1.0%
e09000030	896	1.0%
e09000028	893	1.0%
e09000008	892	1.0%
e06000052	862	0.9%
e09000010	862	0.9%
Other values (368)	80942	88.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

local_authority_highway
Categorical

HIGH CARDINALITY

Distinct	206
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

E10000016	2964
E10000030	2334
E10000012	2064
E10000014	1993
E10000017	1840
Other values (201)	80004

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	E09000032
2nd row	E09000022
3rd row	E09000033
4th row	E09000025
5th row	E09000033

Common Values

Value	Count	Frequency (%)
E10000016	2964	3.3%
E10000030	2334	2.6%
E10000012	2064	2.3%
E10000014	1993	2.2%
E10000017	1840	2.0%
E08000025	1802	2.0%
E10000032	1566	1.7%
E10000015	1398	1.5%
E10000019	1396	1.5%
E10000020	1324	1.5%
Other values (196)	72518	79.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e10000016	2964	3.3%
e10000030	2334	2.6%
e10000012	2064	2.3%
e10000014	1993	2.2%
e10000017	1840	2.0%
e08000025	1802	2.0%
e10000032	1566	1.7%
e10000015	1398	1.5%
e10000019	1396	1.5%
e10000020	1324	1.5%
Other values (196)	72518	79.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_road_class
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.220320398

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	3
median	4
Q3	6
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.44347545
Coefficient of variation (CV)	0.3420298257
Kurtosis	-1.307058069
Mean	4.220320398
Median Absolute Deviation (MAD)	1
Skewness	0.09317430526
Sum	384889
Variance	2.083621376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	40604	44.5%
6	31709	34.8%
4	11490	12.6%
5	4815	5.3%
1	2374	2.6%
2	207	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2374	2.6%
2	207	0.2%
3	40604	44.5%
4	11490	12.6%
5	4815	5.3%
6	31709	34.8%

Value	Count	Frequency (%)
6	31709	34.8%
5	4815	5.3%
4	11490	12.6%
3	40604	44.5%
2	207	0.2%
1	2374	2.6%

first_road_number
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	3068
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	790.6660709

Minimum	0
Maximum	9174
Zeros	36524
Zeros (%)	40.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	34
Q3	538
95-th percentile	5058
Maximum	9174
Range	9174
Interquartile range (IQR)	538

Descriptive statistics

Standard deviation	1580.817743
Coefficient of variation (CV)	1.999349411
Kurtosis	4.261239008
Mean	790.6660709
Median Absolute Deviation (MAD)	34
Skewness	2.290483161
Sum	72107955
Variance	2498984.737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36524	40.0%
1	926	1.0%
6	660	0.7%
4	578	0.6%
3	550	0.6%
23	546	0.6%
5	535	0.6%
2	486	0.5%
38	477	0.5%
40	474	0.5%
Other values (3058)	49443	54.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	36524	40.0%
1	926	1.0%
2	486	0.5%
3	550	0.6%
4	578	0.6%
5	535	0.6%
6	660	0.7%
7	32	< 0.1%
8	136	0.1%
9	67	0.1%

Value	Count	Frequency (%)
9174	2	< 0.1%
9170	4	< 0.1%
9165	2	< 0.1%
9163	1	< 0.1%
9157	3	< 0.1%
9155	1	< 0.1%
9152	4	< 0.1%
9142	1	< 0.1%
9140	2	< 0.1%
9132	3	< 0.1%

road_type
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.256000614

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	6
median	6
Q3	6
95-th percentile	6
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.684878019
Coefficient of variation (CV)	0.3205627516
Kurtosis	0.8405394475
Mean	5.256000614
Median Absolute Deviation (MAD)	0
Skewness	-1.166454629
Sum	479342
Variance	2.83881394
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	66929	73.4%
3	13206	14.5%
1	5580	6.1%
9	2006	2.2%
2	1966	2.2%
7	1512	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5580	6.1%
2	1966	2.2%
3	13206	14.5%
6	66929	73.4%
7	1512	1.7%
9	2006	2.2%

Value	Count	Frequency (%)
9	2006	2.2%
7	1512	1.7%
6	66929	73.4%
3	13206	14.5%
2	1966	2.2%
1	5580	6.1%

speed_limit
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.27011261

Minimum	-1
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	12
Negative (%)	< 0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	20
Q1	30
median	30
Q3	40
95-th percentile	70
Maximum	70
Range	71
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	13.89603165
Coefficient of variation (CV)	0.383126234
Kurtosis	0.1488941296
Mean	36.27011261
Median Absolute Deviation (MAD)	0
Skewness	1.14761133
Sum	3307798
Variance	193.0996957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
30	52260	57.3%
60	11408	12.5%
20	11183	12.3%
40	7867	8.6%
70	4687	5.1%
50	3782	4.1%
-1	12	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	12	< 0.1%
20	11183	12.3%
30	52260	57.3%
40	7867	8.6%
50	3782	4.1%
60	11408	12.5%
70	4687	5.1%

Value	Count	Frequency (%)
70	4687	5.1%
60	11408	12.5%
50	3782	4.1%
40	7867	8.6%
30	52260	57.3%
20	11183	12.3%
-1	12	< 0.1%

junction_detail
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.934878672

Minimum	-1
Maximum	99
Zeros	37978
Zeros (%)	41.6%
Negative	2
Negative (%)	< 0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	2
Q3	3
95-th percentile	9
Maximum	99
Range	100
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	12.61277739
Coefficient of variation (CV)	3.205378983
Kurtosis	50.37446522
Mean	3.934878672
Median Absolute Deviation (MAD)	2
Skewness	7.071211171
Sum	358857
Variance	159.0821536
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	37978	41.6%
3	25626	28.1%
6	8429	9.2%
1	7326	8.0%
9	4705	5.2%
8	1887	2.1%
99	1508	1.7%
2	1300	1.4%
7	1279	1.4%
5	1159	1.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	37978	41.6%
1	7326	8.0%
2	1300	1.4%
3	25626	28.1%
5	1159	1.3%
6	8429	9.2%
7	1279	1.4%
8	1887	2.1%
9	4705	5.2%

Value	Count	Frequency (%)
99	1508	1.7%
9	4705	5.2%
8	1887	2.1%
7	1279	1.4%
6	8429	9.2%
5	1159	1.3%
3	25626	28.1%
2	1300	1.4%
1	7326	8.0%
0	37978	41.6%

junction_control
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.737497122

Minimum	-1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	38298
Negative (%)	42.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	2
Q3	4
95-th percentile	4
Maximum	9
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.510124854
Coefficient of variation (CV)	1.444678568
Kurtosis	-0.9357325121
Mean	1.737497122
Median Absolute Deviation (MAD)	2
Skewness	0.18522575
Sum	158458
Variance	6.300726782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	39998	43.9%
-1	38298	42.0%
2	10407	11.4%
9	1536	1.7%
3	583	0.6%
1	377	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	38298	42.0%
1	377	0.4%
2	10407	11.4%
3	583	0.6%
4	39998	43.9%
9	1536	1.7%

Value	Count	Frequency (%)
9	1536	1.7%
4	39998	43.9%
3	583	0.6%
2	10407	11.4%
1	377	0.4%
-1	38298	42.0%

second_road_class
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.551771401

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	712.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	6
Q3	6
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.015112626
Coefficient of variation (CV)	0.182844817
Kurtosis	2.892798422
Mean	5.551771401
Median Absolute Deviation (MAD)	0
Skewness	-2.072029219
Sum	506316
Variance	1.030453643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	74473	81.7%
3	9566	10.5%
4	3656	4.0%
5	3154	3.5%
1	314	0.3%
2	36	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	314	0.3%
2	36	< 0.1%
3	9566	10.5%
4	3656	4.0%
5	3154	3.5%
6	74473	81.7%

Value	Count	Frequency (%)
6	74473	81.7%
5	3154	3.5%
4	3656	4.0%
3	9566	10.5%
2	36	< 0.1%
1	314	0.3%

second_road_number
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2274
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	220.2319872

Minimum	-1
Maximum	9174
Zeros	77627
Zeros (%)	85.1%
Negative	7
Negative (%)	< 0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1124
Maximum	9174
Range	9175
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	913.6928324
Coefficient of variation (CV)	4.148774408
Kurtosis	25.65555285
Mean	220.2319872
Median Absolute Deviation (MAD)	0
Skewness	4.997485408
Sum	20084937
Variance	834834.5919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	77627	85.1%
1	158	0.2%
406	150	0.2%
4	148	0.2%
41	120	0.1%
3	119	0.1%
40	118	0.1%
2	114	0.1%
6	103	0.1%
23	103	0.1%
Other values (2264)	12439	13.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	7	< 0.1%
0	77627	85.1%
1	158	0.2%
2	114	0.1%
3	119	0.1%
4	148	0.2%
5	77	0.1%
6	103	0.1%
7	10	< 0.1%
8	33	< 0.1%

Value	Count	Frequency (%)
9174	3	< 0.1%
9170	1	< 0.1%
9157	1	< 0.1%
9149	1	< 0.1%
9127	1	< 0.1%
9120	1	< 0.1%
9119	1	< 0.1%
9080	1	< 0.1%
9031	1	< 0.1%
9023	1	< 0.1%

pedestrian_crossing_human_control
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

0	86358
9	3332
2	980
1	386
-1	143

Length

Max length	2
Median length	1
Mean length	1.001568
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	86358	94.7%
9	3332	3.7%
2	980	1.1%
1	386	0.4%
-1	143	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	86358	94.7%
9	3332	3.7%
2	980	1.1%
1	529	0.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

pedestrian_crossing_physical_facilities
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.185309049

Minimum	-1
Maximum	9
Zeros	69269
Zeros (%)	76.0%
Negative	135
Negative (%)	0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	8
Maximum	9
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.44592447
Coefficient of variation (CV)	2.063533111
Kurtosis	2.666856343
Mean	1.185309049
Median Absolute Deviation (MAD)	0
Skewness	1.966227369
Sum	108099
Variance	5.982546515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	69269	76.0%
5	7465	8.2%
4	4903	5.4%
1	3836	4.2%
9	2932	3.2%
8	2460	2.7%
7	199	0.2%
-1	135	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	135	0.1%
0	69269	76.0%
1	3836	4.2%
4	4903	5.4%
5	7465	8.2%
7	199	0.2%
8	2460	2.7%
9	2932	3.2%

Value	Count	Frequency (%)
9	2932	3.2%
8	2460	2.7%
7	199	0.2%
5	7465	8.2%
4	4903	5.4%
1	3836	4.2%
0	69269	76.0%
-1	135	0.1%

light_conditions
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.065307734

Minimum	-1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	6
Maximum	7
Range	8
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.747690004
Coefficient of variation (CV)	0.8462128794
Kurtosis	0.3619659419
Mean	2.065307734
Median Absolute Deviation (MAD)	0
Skewness	1.305012031
Sum	188354
Variance	3.054420351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	64458	70.7%
4	19026	20.9%
6	4835	5.3%
7	2194	2.4%
5	685	0.8%
-1	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	1	< 0.1%
1	64458	70.7%
4	19026	20.9%
5	685	0.8%
6	4835	5.3%
7	2194	2.4%

Value	Count	Frequency (%)
7	2194	2.4%
6	4835	5.3%
5	685	0.8%
4	19026	20.9%
1	64458	70.7%
-1	1	< 0.1%

weather_conditions
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.702047172

Minimum	-1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	8
Maximum	9
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.845785686
Coefficient of variation (CV)	1.084450371
Kurtosis	8.043908159
Mean	1.702047172
Median Absolute Deviation (MAD)	0
Skewness	3.022075815
Sum	155225
Variance	3.406924799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	70729	77.6%
2	11583	12.7%
8	2629	2.9%
9	2423	2.7%
5	1665	1.8%
4	1401	1.5%
7	510	0.6%
3	185	0.2%
6	73	0.1%
-1	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	1	< 0.1%
1	70729	77.6%
2	11583	12.7%
3	185	0.2%
4	1401	1.5%
5	1665	1.8%
6	73	0.1%
7	510	0.6%
8	2629	2.9%
9	2423	2.7%

Value	Count	Frequency (%)
9	2423	2.7%
8	2629	2.9%
7	510	0.6%
6	73	0.1%
5	1665	1.8%
4	1401	1.5%
3	185	0.2%
2	11583	12.7%
1	70729	77.6%
-1	1	< 0.1%

road_surface_conditions
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.391583241

Minimum	-1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	316
Negative (%)	0.3%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	9
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9256901947
Coefficient of variation (CV)	0.6652064838
Kurtosis	40.62687353
Mean	1.391583241
Median Absolute Deviation (MAD)	0
Skewness	5.442426324
Sum	126911
Variance	0.8569023366
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	62698	68.7%
2	26240	28.8%
9	847	0.9%
4	764	0.8%
-1	316	0.3%
5	184	0.2%
3	150	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	316	0.3%
1	62698	68.7%
2	26240	28.8%
3	150	0.2%
4	764	0.8%
5	184	0.2%
9	847	0.9%

Value	Count	Frequency (%)
9	847	0.9%
5	184	0.2%
4	764	0.8%
3	150	0.2%
2	26240	28.8%
1	62698	68.7%
-1	316	0.3%

special_conditions_at_site
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2447395257

Minimum	-1
Maximum	9
Zeros	87309
Zeros (%)	95.7%
Negative	218
Negative (%)	0.2%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	9
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.318553879
Coefficient of variation (CV)	5.387580429
Kurtosis	32.20701676
Mean	0.2447395257
Median Absolute Deviation (MAD)	0
Skewness	5.673150744
Sum	22320
Variance	1.738584331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	87309	95.7%
9	1452	1.6%
4	1106	1.2%
7	317	0.3%
5	228	0.3%
-1	218	0.2%
1	213	0.2%
3	158	0.2%
6	151	0.2%
2	47	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	218	0.2%
0	87309	95.7%
1	213	0.2%
2	47	0.1%
3	158	0.2%
4	1106	1.2%
5	228	0.3%
6	151	0.2%
7	317	0.3%
9	1452	1.6%

Value	Count	Frequency (%)
9	1452	1.6%
7	317	0.3%
6	151	0.2%
5	228	0.3%
4	1106	1.2%
3	158	0.2%
2	47	0.1%
1	213	0.2%
0	87309	95.7%
-1	218	0.2%

carriageway_hazards
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1805940855

Minimum	-1
Maximum	9
Zeros	87881
Zeros (%)	96.4%
Negative	208
Negative (%)	0.2%
Memory size	712.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	9
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.149791454
Coefficient of variation (CV)	6.366717113
Kurtosis	47.72392671
Mean	0.1805940855
Median Absolute Deviation (MAD)	0
Skewness	6.898491154
Sum	16470
Variance	1.322020389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	87881	96.4%
9	1191	1.3%
2	1079	1.2%
7	314	0.3%
1	220	0.2%
-1	208	0.2%
6	155	0.2%
3	151	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	208	0.2%
0	87881	96.4%
1	220	0.2%
2	1079	1.2%
3	151	0.2%
6	155	0.2%
7	314	0.3%
9	1191	1.3%

Value	Count	Frequency (%)
9	1191	1.3%
7	314	0.3%
6	155	0.2%
3	151	0.2%
2	1079	1.2%
1	220	0.2%
0	87881	96.4%
-1	208	0.2%

urban_or_rural_area
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

1	61737
2	29448
3	14

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	61737	67.7%
2	29448	32.3%
3	14	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	61737	67.7%
2	29448	32.3%
3	14	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

did_police_officer_attend_scene_of_accident
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

1	62442
2	19638
3	9118
-1	1

Length

Max length	2
Median length	1
Mean length	1.000010965
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	3
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	62442	68.5%
2	19638	21.5%
3	9118	10.0%
-1	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	62443	68.5%
2	19638	21.5%
3	9118	10.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

trunk_road_flag
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

2	79222
-1	6710
1	5267

Length

Max length	2
Median length	1
Mean length	1.073575368
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	79222	86.9%
-1	6710	7.4%
1	5267	5.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2	79222	86.9%
1	11977	13.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

lsoa_of_accident_location
Categorical

HIGH CARDINALITY

Distinct	25931
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Memory size	712.6 KiB

-1	3851
E01032739	70
E01004736	65
E01016012	50
E01033708	40
Other values (25926)	87123

Length

Max length	9
Median length	9
Mean length	8.704415619
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8160 ?
Unique (%)	8.9%

Sample

1st row	E01004576
2nd row	E01003034
3rd row	E01004726
4th row	E01003617
5th row	E01004763

Common Values

Value	Count	Frequency (%)
-1	3851	4.2%
E01032739	70	0.1%
E01004736	65	0.1%
E01016012	50	0.1%
E01033708	40	< 0.1%
E01003728	39	< 0.1%
E01018648	38	< 0.1%
E01021800	37	< 0.1%
E01004727	37	< 0.1%
E01002444	36	< 0.1%
Other values (25921)	86936	95.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1	3851	4.2%
e01032739	70	0.1%
e01004736	65	0.1%
e01016012	50	0.1%
e01033708	40	< 0.1%
e01003728	39	< 0.1%
e01018648	38	< 0.1%
e01021800	37	< 0.1%
e01004727	37	< 0.1%
e01033269	36	< 0.1%
Other values (25921)	86936	95.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	accident_index	accident_year	accident_reference	location_easting_osgr	location_northing_osgr	longitude	latitude	police_force	accident_severity	number_of_vehicles	number_of_casualties	date	day_of_week	time	local_authority_district	local_authority_ons_district	local_authority_highway	first_road_class	first_road_number	road_type	speed_limit	junction_detail	junction_control	second_road_class	second_road_number	pedestrian_crossing_human_control	pedestrian_crossing_physical_facilities	light_conditions	weather_conditions	road_surface_conditions	urban_or_rural_area	did_police_officer_attend_scene_of_accident	trunk_road_flag	lsoa_of_accident_location
0	2020010219808	2020	10219808	521389.0	175144.0	-0.254001	51.462262	1	3	1	1	04/02/2020	3	09:00	10	E09000032	E09000032	6	0	6	20	0	-1	6	0	9	9	1	9	9	1	3	2	E01004576
1	2020010220496	2020	10220496	529337.0	176237.0	-0.139253	51.470327	1	3	1	2	27/04/2020	2	13:55	9	E09000022	E09000022	3	3036	6	20	9	2	6	0	0	4	1	1	1	1	1	2	E01003034
2	2020010228005	2020	10228005	526432.0	182761.0	-0.178719	51.529614	1	3	1	1	01/01/2020	4	01:25	1	E09000033	E09000033	5	0	6	30	3	1	6	0	0	0	4	1	2	1	1	2	E01004726
3	2020010228006	2020	10228006	538676.0	184371.0	-0.001683	51.541210	1	2	1	1	01/01/2020	4	01:50	17	E09000025	E09000025	3	11	6	30	0	-1	6	0	0	4	4	1	1	1	1	2	E01003617
4	2020010228011	2020	10228011	529324.0	181286.0	-0.137592	51.515704	1	3	1	2	01/01/2020	4	02:25	1	E09000033	E09000033	3	40	6	30	3	4	5	0	0	0	4	1	1	1	1	2	E01004763
5	2020010228012	2020	10228012	537193.0	177105.0	-0.025880	51.476278	1	3	1	1	01/01/2020	4	01:30	7	E09000023	E09000023	3	2209	2	20	3	4	6	0	0	0	4	1	1	1	1	2	E01003304
6	2020010228014	2020	10228014	539764.0	179234.0	0.011959	51.494780	1	3	2	1	01/01/2020	4	03:43	6	E09000011	E09000011	6	0	6	30	3	4	6	0	0	0	4	1	2	1	1	2	E01001667
7	2020010228017	2020	10228017	536115.0	182297.0	-0.039390	51.523195	1	2	2	1	01/01/2020	4	03:00	5	E09000030	E09000030	3	11	3	30	9	4	6	0	0	0	4	8	2	1	1	2	E01004261
8	2020010228018	2020	10228018	530876.0	191335.0	-0.111500	51.605653	1	3	2	1	01/01/2020	4	04:00	31	E09000014	E09000014	3	105	6	20	9	4	6	0	0	0	4	1	1	1	1	2	E01002102
9	2020010228020	2020	10228020	529718.0	192342.0	-0.127840	51.614971	1	3	2	1	01/01/2020	4	03:25	32	E09000010	E09000010	3	406	3	30	6	2	3	406	0	5	4	1	1	1	1	2	E01001530

Last rows

	accident_index	accident_year	accident_reference	location_easting_osgr	location_northing_osgr	longitude	latitude	police_force	accident_severity	number_of_vehicles	number_of_casualties	date	day_of_week	time	local_authority_district	local_authority_ons_district	local_authority_highway	first_road_class	first_road_number	road_type	speed_limit	junction_detail	junction_control	second_road_class	second_road_number	pedestrian_crossing_human_control	pedestrian_crossing_physical_facilities	light_conditions	weather_conditions	road_surface_conditions	carriageway_hazards	urban_or_rural_area	did_police_officer_attend_scene_of_accident	trunk_road_flag	lsoa_of_accident_location
91189	2020991023621	2020	991023621	341791.0	733677.0	-2.946947	56.491558	99	2	1	1	10/11/2020	3	10:30	918	S12000042	S12000042	6	0	7	20	3	4	6	0	0	0	1	9	2	0	1	2	-1	-1
91190	2020991023880	2020	991023880	342979.0	731116.0	-2.927095	56.468699	99	3	1	1	14/12/2020	2	17:00	918	S12000042	S12000042	6	0	6	30	9	4	6	0	0	0	4	1	2	0	1	2	-1	-1
91191	2020991024039	2020	991024039	298547.0	696827.0	-3.634775	56.153290	99	3	2	1	15/09/2020	3	07:10	934	S12000024	S12000024	3	977	6	30	0	-1	6	0	2	4	1	1	1	0	2	1	-1	-1
91192	2020991024209	2020	991024209	294074.0	581458.0	-3.662274	55.116161	99	3	2	2	01/08/2020	7	13:27	917	S12000006	S12000006	3	76	6	60	9	4	6	0	0	0	1	1	1	0	2	1	-1	-1
91193	2020991024526	2020	991024526	286242.0	717023.0	-3.841439	56.331864	99	3	1	1	17/11/2020	3	12:00	934	S12000024	S12000024	6	0	9	60	0	-1	6	0	0	0	1	2	2	7	2	2	-1	-1
91194	2020991027064	2020	991027064	343034.0	731654.0	-2.926320	56.473539	99	2	2	1	12/08/2020	4	14:30	918	S12000042	S12000042	4	959	6	30	1	4	4	959	0	0	1	1	1	0	1	1	-1	-1
91195	2020991029573	2020	991029573	257963.0	658891.0	-4.267565	55.802353	99	3	1	1	13/11/2020	6	15:05	922	S12000011	S12000011	6	0	9	30	3	4	6	0	0	0	1	1	1	0	1	2	-1	-1
91196	2020991030297	2020	991030297	383664.0	810646.0	-2.271903	57.186317	99	2	2	1	15/04/2020	4	12:42	910	S12000033	S12000033	4	979	6	60	8	-1	6	0	0	0	1	1	1	0	2	1	-1	-1
91197	2020991030900	2020	991030900	277161.0	674852.0	-3.968753	55.950940	99	3	2	1	15/12/2020	3	14:00	932	S12000044	S12000044	6	0	6	30	3	4	6	0	0	0	1	1	1	0	1	2	-1	-1
91198	2020991032575	2020	991032575	240402.0	681950.0	-4.561040	56.003843	99	3	1	1	25/08/2020	3	13:50	916	S12000039	S12000039	6	0	6	30	0	-1	6	0	0	0	1	1	1	2	1	1	-1	-1

Most frequently occurring

	accident_year	location_easting_osgr	location_northing_osgr	longitude	latitude	police_force	accident_severity	number_of_vehicles	number_of_casualties	date	day_of_week	time	local_authority_district	local_authority_ons_district	local_authority_highway	first_road_class	first_road_number	road_type	speed_limit	junction_detail	junction_control	second_road_class	second_road_number	pedestrian_crossing_human_control	pedestrian_crossing_physical_facilities	light_conditions	weather_conditions	road_surface_conditions	special_conditions_at_site	carriageway_hazards	urban_or_rural_area	did_police_officer_attend_scene_of_accident	trunk_road_flag	lsoa_of_accident_location	# duplicates
0	2020	443811.0	434219.0	-1.336281	53.80245	13	3	1	1	24/02/2020	2	07:45	204	E08000035	E08000035	2	1	3	70	0	-1	6	0	0	0	1	5	5	0	0	2	1	1	E01011297	2

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length